﻿USE [RestaurantManagement]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		<Nguyễn Đức Thắng>
-- Create date: <15/03/2013>
-- Get_All_Restaurants
-- =============================================
CREATE procedure [dbo].[Get_Stock_ById]
	@StockID UNIQUEIDENTIFIER
AS
BEGIN
	SELECT 	StockID,
			StockCode,
			StockName,
			Description,
			RestaurantID,
			IsActive
	 FROM	Production.[Stock]
	WHERE	StockID = @StockID
END